import pandas as pd
import numpy as np
df=pd.read_excel('static/ziyuan.xlsx')

print(df)
print(type(df))
a=[]
b=[]
c=[]
df=df.dropna()
print(df)
wzlist=np.array(df).tolist()
print(wzlist)
#df.to_html('static/ziyuan4.html',encoding='utf_8_sig')
for i in wzlist:
    a.append(i[0])
    b.append(i[1])
    c.append(i[2])

print(a,b,c)
b=set(b)
b=list(b)

print(b)
print(len(b))